AIB Group 15 - Data Profiling Report

Dataset statistics

Number of variables	12
Number of observations	10324
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	206
Duplicate rows (%)	2.0%
Total size in memory	968.0 KiB
Average record size in memory	96.0 B

Variable types

Numeric	12

Alerts

Dataset has 206 (2.0%) duplicate rows	Duplicates
`country_costmean` is highly overall correlated with `country_costsum` and 8 other fields	High correlation
`country_costsum` is highly overall correlated with `country_costmean` and 8 other fields	High correlation
`country_insmean` is highly overall correlated with `country_costmean` and 8 other fields	High correlation
`country_inssum` is highly overall correlated with `country_costmean` and 8 other fields	High correlation
`country_qtymean` is highly overall correlated with `country_costmean` and 8 other fields	High correlation
`country_qtysum` is highly overall correlated with `country_costmean` and 8 other fields	High correlation
`country_valmean` is highly overall correlated with `country_costmean` and 8 other fields	High correlation
`country_valsum` is highly overall correlated with `country_costmean` and 8 other fields	High correlation
`country_weightmean` is highly overall correlated with `country_costmean` and 8 other fields	High correlation
`country_weightsum` is highly overall correlated with `country_costmean` and 8 other fields	High correlation

Reproduction

Analysis started	2024-03-14 12:53:34.559322
Analysis finished	2024-03-14 12:53:42.111325
Duration	7.55 seconds
Software version	ydata-profiling vv4.6.5
Download configuration	config.json

country_qtycount
Real number (ℝ)

Distinct	98
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	107.07594

Minimum	1
Maximum	343
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	1
5-th percentile	18
Q1	58
median	87
Q3	142
95-th percentile	298
Maximum	343
Range	342
Interquartile range (IQR)	84

Descriptive statistics

Standard deviation	75.924561
Coefficient of variation (CV)	0.7090721
Kurtosis	1.8483416
Mean	107.07594
Median Absolute Deviation (MAD)	39
Skewness	1.393988
Sum	1105452
Variance	5764.539
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
343	343	3.3%
82	328	3.2%
298	298	2.9%
98	294	2.8%
93	279	2.7%
87	261	2.5%
77	231	2.2%
228	228	2.2%
75	225	2.2%
210	210	2.0%
Other values (88)	7627	73.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	13	0.1%
2	22	0.2%
3	45	0.4%
4	16	0.2%
5	40	0.4%
6	48	0.5%
7	21	0.2%
8	24	0.2%
9	9	0.1%
10	70	0.7%

Value	Count	Frequency (%)
343	343	3.3%
298	298	2.9%
228	228	2.2%
210	210	2.0%
196	196	1.9%
185	185	1.8%
171	171	1.7%
167	167	1.6%
164	164	1.6%
149	149	1.4%

del_date_scheduled_yr
Real number (ℝ)

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2011.2576

Minimum	2006
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	2006
5-th percentile	2007
Q1	2009
median	2011
Q3	2013
95-th percentile	2015
Maximum	2015
Range	9
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.4812415
Coefficient of variation (CV)	0.0012336766
Kurtosis	-1.1597924
Mean	2011.2576
Median Absolute Deviation (MAD)	2
Skewness	-0.13721384
Sum	20764223
Variance	6.1565592
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2014	1528	14.8%
2012	1273	12.3%
2013	1272	12.3%
2009	1253	12.1%
2010	1204	11.7%
2008	1029	10.0%
2015	1017	9.9%
2011	1011	9.8%
2007	672	6.5%
2006	65	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2006	65	0.6%
2007	672	6.5%
2008	1029	10.0%
2009	1253	12.1%
2010	1204	11.7%
2011	1011	9.8%
2012	1273	12.3%
2013	1272	12.3%
2014	1528	14.8%
2015	1017	9.9%

Value	Count	Frequency (%)
2015	1017	9.9%
2014	1528	14.8%
2013	1272	12.3%
2012	1273	12.3%
2011	1011	9.8%
2010	1204	11.7%
2009	1253	12.1%
2008	1029	10.0%
2007	672	6.5%
2006	65	0.6%

country_qtysum
Real number (ℝ)

HIGH CORRELATION

Distinct	213
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1859474.4

Minimum	14
Maximum	15436074
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	14
5-th percentile	15194
Q1	311950
median	1016903
Q3	2446649
95-th percentile	6521076
Maximum	15436074
Range	15436060
Interquartile range (IQR)	2134699

Descriptive statistics

Standard deviation	2547577.7
Coefficient of variation (CV)	1.3700526
Kurtosis	13.085116
Mean	1859474.4
Median Absolute Deviation (MAD)	927549
Skewness	3.1691201
Sum	1.9197214 × 10¹⁰
Variance	6.490152 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
65366	343	3.3%
595062	298	2.9%
15194	228	2.2%
3548124	210	2.0%
15436074	196	1.9%
2443751	185	1.8%
1515631	171	1.7%
3779574	167	1.6%
1145218	164	1.6%
5829963	149	1.4%
Other values (203)	8213	79.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
14	2	< 0.1%
50	3	< 0.1%
55	3	< 0.1%
80	1	< 0.1%
115	10	0.1%
140	3	< 0.1%
163	4	< 0.1%
165	2	< 0.1%
169	6	0.1%
200	3	< 0.1%

Value	Count	Frequency (%)
15436074	196	1.9%
6909336	140	1.4%
6811335	105	1.0%
6521076	135	1.3%
5829963	149	1.4%
5176819	145	1.4%
5113821	83	0.8%
4576185	82	0.8%
4316624	82	0.8%
3988402	77	0.7%

country_qtymean
Real number (ℝ)

HIGH CORRELATION

Distinct	215
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18332.535

Minimum	7
Maximum	78755.48
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	7
5-th percentile	190.57143
Q1	4395.1531
median	12683.296
Q3	26875.3
95-th percentile	58862.9
Maximum	78755.48
Range	78748.48
Interquartile range (IQR)	22480.147

Descriptive statistics

Standard deviation	18582.414
Coefficient of variation (CV)	1.0136303
Kurtosis	1.1920652
Mean	18332.535
Median Absolute Deviation (MAD)	10137.374
Skewness	1.3261977
Sum	1.8926509 × 10⁸
Variance	3.453061 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
190.5714286	343	3.3%
1996.852349	298	2.9%
66.64035088	228	2.2%
16895.82857	210	2.0%
78755.47959	196	1.9%
13209.46486	185	1.8%
8863.339181	171	1.7%
22632.17964	167	1.6%
6983.036585	164	1.6%
39127.26846	149	1.4%
Other values (205)	8213	79.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7	2	< 0.1%
13.10526316	19	0.2%
16.42857143	7	0.1%
18.33333333	3	< 0.1%
28.16666667	6	0.1%
38.33333333	3	< 0.1%
40.75	4	< 0.1%
41.83333333	24	0.2%
46.66666667	3	< 0.1%
50	3	< 0.1%

Value	Count	Frequency (%)
78755.47959	196	1.9%
67511	55	0.5%
64869.85714	105	1.0%
62537.32609	46	0.4%
61612.3012	83	0.8%
58862.9	50	0.5%
55807.13415	82	0.8%
52641.7561	82	0.8%
51797.42857	77	0.7%
50769.55556	18	0.2%

country_valsum
Real number (ℝ)

HIGH CORRELATION

Distinct	216
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15267673

Minimum	0
Maximum	67742340
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	409852.36
Q1	2848863.5
median	10804267
Q3	21597701
95-th percentile	57488655
Maximum	67742340
Range	67742340
Interquartile range (IQR)	18748837

Descriptive statistics

Standard deviation	16510383
Coefficient of variation (CV)	1.0813949
Kurtosis	2.0040779
Mean	15267673
Median Absolute Deviation (MAD)	8856917.1
Skewness	1.5874752
Sum	1.5762345 × 10¹¹
Variance	2.7259274 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1283746.29	343	3.3%
7079591.28	298	2.9%
468161.63	228	2.2%
33869606.52	210	2.0%
67742339.79	196	1.9%
35452389.84	185	1.8%
14919430.41	171	1.7%
28476197.72	167	1.6%
12069370.48	164	1.6%
26199468.38	149	1.4%
Other values (206)	8213	79.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
9.36	8	0.1%
187.28	10	0.1%
451.25	2	< 0.1%
630	1	< 0.1%
2064	2	< 0.1%
3580	3	< 0.1%
3600	1	< 0.1%
4080	7	0.1%
4617.35	3	< 0.1%

Value	Count	Frequency (%)
67742339.79	196	1.9%
64697700.08	105	1.0%
59751187.71	135	1.3%
57488655.23	140	1.4%
55933176.76	145	1.4%
47265256.05	82	0.8%
40242848.23	83	0.8%
36047667.06	93	0.9%
35452389.84	185	1.8%
33869606.52	210	2.0%

country_valmean
Real number (ℝ)

HIGH CORRELATION

Distinct	216
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	157650.57

Minimum	0
Maximum	616168.57
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	3742.7006
Q1	41704.813
median	110386.38
Q3	222981.54
95-th percentile	442601.39
Maximum	616168.57
Range	616168.57
Interquartile range (IQR)	181276.73

Descriptive statistics

Standard deviation	144066.26
Coefficient of variation (CV)	0.91383283
Kurtosis	0.72852973
Mean	157650.57
Median Absolute Deviation (MAD)	81248.156
Skewness	1.1578605
Sum	1.6275845 × 10⁹
Variance	2.0755089 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3742.700554	343	3.3%
23757.01772	298	2.9%
2053.340482	228	2.2%
161283.8406	210	2.0%
345624.1826	196	1.9%
191634.5397	185	1.8%
87248.13105	171	1.7%
170516.154	167	1.6%
73593.72244	164	1.6%
175835.3583	149	1.4%
Other values (206)	8213	79.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1.17	8	0.1%
18.728	10	0.1%
225.625	2	< 0.1%
582.8571429	7	0.1%
630	1	< 0.1%
815	6	0.1%
1032	2	< 0.1%
1152.631579	19	0.2%
1193.333333	3	< 0.1%

Value	Count	Frequency (%)
616168.5722	105	1.0%
581951.2	10	0.1%
576405.5616	82	0.8%
574595.3337	46	0.4%
534416.7527	55	0.5%
492998.1667	18	0.2%
484853.5931	83	0.8%
444717.7256	50	0.5%
442601.3904	135	1.3%
437305.39	62	0.6%

country_inssum
Real number (ℝ)

HIGH CORRELATION

Distinct	214
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23223.585

Minimum	0
Maximum	123010.43
Zeros	9
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	498.73
Q1	4740.65
median	14598.43
Q3	31070.02
95-th percentile	72852.29
Maximum	123010.43
Range	123010.43
Interquartile range (IQR)	26329.37

Descriptive statistics

Standard deviation	25539.994
Coefficient of variation (CV)	1.0997438
Kurtosis	3.0096955
Mean	23223.585
Median Absolute Deviation (MAD)	12591.67
Skewness	1.703769
Sum	2.3976029 × 10⁸
Variance	6.522913 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1533.55	343	3.3%
13904.9	298	2.9%
535.39	228	2.2%
72852.29	210	2.0%
123010.43	196	1.9%
69622.1	185	1.8%
31461.79	171	1.7%
35536.51	167	1.6%
14407.37005	164	1.6%
56469.83	149	1.4%
Other values (204)	8213	79.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	0.1%
0.00245	2	< 0.1%
0.0049	2	< 0.1%
0.0098	4	< 0.1%
0.01225	10	0.1%
0.0245	10	0.1%
0.02695	11	0.1%
0.0294	12	0.1%
0.0343	14	0.1%
0.37	10	0.1%

Value	Count	Frequency (%)
123010.43	196	1.9%
82614.19	140	1.4%
72852.29	210	2.0%
71458.04	145	1.4%
69622.1	185	1.8%
67697.39	105	1.0%
63861.56	135	1.3%
62443.64	93	0.9%
60052.38	83	0.8%
56469.83	149	1.4%

country_insmean
Real number (ℝ)

HIGH CORRELATION

Distinct	207
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	233.44259

Minimum	0
Maximum	863.37778
Zeros	9
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	0
5-th percentile	4.4709913
Q1	66.728333
median	177.64917
Q3	367.78444
95-th percentile	644.73705
Maximum	863.37778
Range	863.37778
Interquartile range (IQR)	301.05611

Descriptive statistics

Standard deviation	206.33589
Coefficient of variation (CV)	0.8838828
Kurtosis	-0.21052914
Mean	233.44259
Median Absolute Deviation (MAD)	132.19583
Skewness	0.8788836
Sum	2410061.3
Variance	42574.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.470991254	343	3.3%
46.66073826	298	2.9%
2.348201754	228	2.2%
346.9156667	210	2.0%
627.6042347	196	1.9%
376.3356757	185	1.8%
183.987076	171	1.7%
212.7934731	167	1.6%
87.84981738	164	1.6%
378.9921477	149	1.4%
Other values (197)	8213	79.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	0.1%
0.00245	65	0.6%
0.037	10	0.1%
0.265	2	< 0.1%
1.04	1	< 0.1%
1.051428571	7	0.1%
1.215	2	< 0.1%
1.383333333	6	0.1%
1.68147	5	< 0.1%
1.81	3	< 0.1%

Value	Count	Frequency (%)
863.3777778	18	0.2%
859.8846774	62	0.6%
723.5226506	83	0.8%
719.873	10	0.1%
671.4369892	93	0.9%
661.0059701	67	0.6%
650.1213415	82	0.8%
644.7370476	105	1.0%
635.0326087	46	0.4%
631.2508696	23	0.2%

country_weightsum
Real number (ℝ)

HIGH CORRELATION

Distinct	217
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	540707.61

Minimum	22.066213
Maximum	4149553
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	22.066213
5-th percentile	9844.8752
Q1	90420.547
median	240889.72
Q3	716202.34
95-th percentile	2735925.6
Maximum	4149553
Range	4149530.9
Interquartile range (IQR)	625781.79

Descriptive statistics

Standard deviation	776784.31
Coefficient of variation (CV)	1.4366069
Kurtosis	8.0659364
Mean	540707.61
Median Absolute Deviation (MAD)	199482.98
Skewness	2.7244361
Sum	5.5822654 × 10⁹
Variance	6.0339387 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11088.71732	343	3.3%
90420.54667	298	2.9%
2068.879046	228	2.2%
586052.9309	210	2.0%
2735925.636	196	1.9%
1079001.271	185	1.8%
394580.7796	171	1.7%
937767.9118	167	1.6%
174738.0976	164	1.6%
929607.9252	149	1.4%
Other values (207)	8213	79.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22.06621257	2	< 0.1%
31.26923077	1	< 0.1%
34.34329251	2	< 0.1%
86.35614681	2	< 0.1%
97.39517977	3	< 0.1%
104.9684961	2	< 0.1%
112.8086766	1	< 0.1%
122.6546161	2	< 0.1%
135.9775433	1	< 0.1%
182.0935448	1	< 0.1%

Value	Count	Frequency (%)
4149552.998	145	1.4%
3442204.674	82	0.8%
3248952.975	105	1.0%
2735925.636	196	1.9%
2054455.384	18	0.2%
1683935.523	135	1.3%
1682090.663	23	0.2%
1622786.905	97	0.9%
1531660.806	140	1.4%
1478512.788	21	0.2%

country_weightmean
Real number (ℝ)

HIGH CORRELATION

Distinct	217
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6108.9177

Minimum	9.0740309
Maximum	114136.41
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	9.0740309
5-th percentile	32.328622
Q1	1223.949
median	2997.078
Q3	7310.1482
95-th percentile	16938.648
Maximum	114136.41
Range	114127.34
Interquartile range (IQR)	6086.1992

Descriptive statistics

Standard deviation	9822.0179
Coefficient of variation (CV)	1.6078164
Kurtosis	39.819736
Mean	6108.9177
Median Absolute Deviation (MAD)	2430.0001
Skewness	5.2429587
Sum	63068466
Variance	96472035
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32.32862192	343	3.3%
303.4246533	298	2.9%
9.074030902	228	2.2%
2790.728243	210	2.0%
13958.80426	196	1.9%
5832.439302	185	1.8%
2307.489939	171	1.7%
5615.376718	167	1.6%
1065.476205	164	1.6%
6238.979364	149	1.4%
Other values (207)	8213	79.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.074030902	228	2.2%
11.03310628	2	< 0.1%
17.17164625	2	< 0.1%
25.64342439	8	0.1%
31.26923077	1	< 0.1%
32.32862192	343	3.3%
32.46505992	3	< 0.1%
34.59694459	19	0.2%
36.80701992	7	0.1%
43.17807341	2	< 0.1%

Value	Count	Frequency (%)
114136.4102	18	0.2%
95698.89151	2	< 0.1%
73805.4992	19	0.2%
73134.37663	23	0.2%
70405.37084	21	0.2%
63799.26101	3	< 0.1%
62165.48183	5	< 0.1%
41978.10578	82	0.8%
30942.40928	105	1.0%
28962.60299	3	< 0.1%

country_costsum
Real number (ℝ)

HIGH CORRELATION

Distinct	217
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11730932

Minimum	693.54338
Maximum	1.4661471 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	693.54338
5-th percentile	139020.26
Q1	1348093.3
median	3915463.7
Q3	8886112.7
95-th percentile	49600498
Maximum	1.4661471 × 10⁸
Range	1.4661401 × 10⁸
Interquartile range (IQR)	7538019.4

Descriptive statistics

Standard deviation	23483098
Coefficient of variation (CV)	2.0018101
Kurtosis	19.024598
Mean	11730932
Median Absolute Deviation (MAD)	3000868.5
Skewness	4.0988546
Sum	1.2111014 × 10¹¹
Variance	5.5145588 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
802448.647	343	3.3%
5247787.762	298	2.9%
63439.20959	228	2.2%
28422812.46	210	2.0%
146614708.5	196	1.9%
25600163.35	185	1.8%
5847370.596	171	1.7%
9692430.206	167	1.6%
5882010.138	164	1.6%
67323748.88	149	1.4%
Other values (207)	8213	79.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
693.5433768	1	< 0.1%
1058.055385	1	< 0.1%
1058.103853	2	< 0.1%
1218.415706	7	0.1%
1227.934208	1	< 0.1%
1406.44964	2	< 0.1%
3896.307105	3	< 0.1%
4329.526827	6	0.1%
5023.03443	2	< 0.1%
5070.964957	2	< 0.1%

Value	Count	Frequency (%)
146614708.5	196	1.9%
83953821.82	83	0.8%
67323748.88	149	1.4%
49600497.97	145	1.4%
44299928.34	67	0.6%
35589662.84	70	0.7%
33728085.7	140	1.4%
30135256.98	82	0.8%
28422812.46	210	2.0%
27575718.15	93	0.9%

country_costmean
Real number (ℝ)

HIGH CORRELATION

Distinct	217
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	110061.08

Minimum	174.05939
Maximum	1011491.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.8 KiB

Quantile statistics

Minimum	174.05939
5-th percentile	2339.5004
Q1	24615.402
median	45342.51
Q3	99041.863
95-th percentile	451837.24
Maximum	1011491.8
Range	1011317.8
Interquartile range (IQR)	74426.461

Descriptive statistics

Standard deviation	173978.85
Coefficient of variation (CV)	1.5807482
Kurtosis	9.3265142
Mean	110061.08
Median Absolute Deviation (MAD)	27732.484
Skewness	2.9517561
Sum	1.1362706 × 10⁹
Variance	3.0268642 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2339.500429	343	3.3%
17610.02605	298	2.9%
278.2421473	228	2.2%
135346.726	210	2.0%
748034.2271	196	1.9%
138379.2613	185	1.8%
34195.14968	171	1.7%
58038.50423	167	1.6%
35865.91547	164	1.6%
451837.2408	149	1.4%
Other values (207)	8213	79.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
174.0593865	7	0.1%
278.2421473	228	2.2%
529.0519263	2	< 0.1%
634.6577817	19	0.2%
693.5433768	1	< 0.1%
703.2248202	2	< 0.1%
721.5878045	6	0.1%
1058.055385	1	< 0.1%
1227.934208	1	< 0.1%
1298.769035	3	< 0.1%

Value	Count	Frequency (%)
1011491.829	83	0.8%
995521.9968	18	0.2%
832038.8111	2	< 0.1%
748034.2271	196	1.9%
661192.9603	67	0.6%
656607.6431	21	0.2%
653576.2739	19	0.2%
639339.7429	23	0.2%
562903.4522	5	< 0.1%
554692.5408	3	< 0.1%

Auto

Heatmap
Table

	country_costmean	country_costsum	country_insmean	country_inssum	country_qtycount	country_qtymean	country_qtysum	country_valmean	country_valsum	country_weightmean	country_weightsum	del_date_scheduled_yr
country_costmean	1.000	0.868	0.827	0.747	-0.017	0.807	0.764	0.838	0.764	0.865	0.837	0.097
country_costsum	0.868	1.000	0.762	0.890	0.391	0.730	0.872	0.741	0.894	0.712	0.889	0.036
country_insmean	0.827	0.762	1.000	0.879	0.009	0.910	0.848	0.963	0.861	0.846	0.836	0.027
country_inssum	0.747	0.890	0.879	1.000	0.411	0.814	0.948	0.831	0.976	0.703	0.885	-0.008
country_qtycount	-0.017	0.391	0.009	0.411	1.000	-0.011	0.344	-0.045	0.391	-0.129	0.240	0.031
country_qtymean	0.807	0.730	0.910	0.814	-0.011	1.000	0.905	0.942	0.851	0.824	0.802	0.167
country_qtysum	0.764	0.872	0.848	0.948	0.344	0.905	1.000	0.850	0.973	0.725	0.881	0.128
country_valmean	0.838	0.741	0.963	0.831	-0.045	0.942	0.850	1.000	0.862	0.891	0.850	0.127
country_valsum	0.764	0.894	0.861	0.976	0.391	0.851	0.973	0.862	1.000	0.740	0.912	0.081
country_weightmean	0.865	0.712	0.846	0.703	-0.129	0.824	0.725	0.891	0.740	1.000	0.895	0.235
country_weightsum	0.837	0.889	0.836	0.885	0.240	0.802	0.881	0.850	0.912	0.895	1.000	0.175
del_date_scheduled_yr	0.097	0.036	0.027	-0.008	0.031	0.167	0.128	0.127	0.081	0.235	0.175	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	country_qtycount	del_date_scheduled_yr	country_qtysum	country_qtymean	country_valsum	country_valmean	country_inssum	country_insmean	country_weightsum	country_weightmean	country_costsum	country_costmean
0	14	2006	29553	2110.928571	370713.70	26479.550000	0.03430	0.002450	55207.914059	3943.422433	9.418457e+05	67274.693036
1	12	2006	152998	12749.833333	1358232.36	113186.030000	0.02940	0.002450	13594.489692	1132.874141	1.136473e+06	94706.044620
2	14	2006	29553	2110.928571	370713.70	26479.550000	0.03430	0.002450	55207.914059	3943.422433	9.418457e+05	67274.693036
3	12	2006	152998	12749.833333	1358232.36	113186.030000	0.02940	0.002450	13594.489692	1132.874141	1.136473e+06	94706.044620
4	12	2006	152998	12749.833333	1358232.36	113186.030000	0.02940	0.002450	13594.489692	1132.874141	1.136473e+06	94706.044620
5	11	2006	58207	5291.545455	160146.55	14558.777273	0.02695	0.002450	27914.062086	2537.642008	4.063337e+05	36939.428492
6	96	2007	1506964	15697.541667	16485986.84	171729.029583	17251.09575	179.698914	240889.718222	2509.267898	4.384424e+06	45671.079118
7	1	2006	16667	16667.000000	60834.55	60834.550000	0.00245	0.002450	1590.200683	1590.200683	1.580671e+04	15806.705846
8	11	2006	58207	5291.545455	160146.55	14558.777273	0.02695	0.002450	27914.062086	2537.642008	4.063337e+05	36939.428492
9	96	2007	1506964	15697.541667	16485986.84	171729.029583	17251.09575	179.698914	240889.718222	2509.267898	4.384424e+06	45671.079118

	country_qtycount	del_date_scheduled_yr	country_qtysum	country_qtymean	country_valsum	country_valmean	country_inssum	country_insmean	country_weightsum	country_weightmean	country_costsum	country_costmean
10314	105	2015	6811335	64869.857143	64697700.08	616168.572190	67697.39	644.737048	3.248953e+06	30942.409284	2.634203e+07	250876.519554
10315	105	2015	6811335	64869.857143	64697700.08	616168.572190	67697.39	644.737048	3.248953e+06	30942.409284	2.634203e+07	250876.519554
10316	105	2015	6811335	64869.857143	64697700.08	616168.572190	67697.39	644.737048	3.248953e+06	30942.409284	2.634203e+07	250876.519554
10317	105	2015	6811335	64869.857143	64697700.08	616168.572190	67697.39	644.737048	3.248953e+06	30942.409284	2.634203e+07	250876.519554
10318	50	2015	2943145	58862.900000	22235886.28	444717.725600	23665.57	473.311400	4.029754e+05	8059.508087	4.251579e+06	85031.585415
10319	50	2015	2943145	58862.900000	22235886.28	444717.725600	23665.57	473.311400	4.029754e+05	8059.508087	4.251579e+06	85031.585415
10320	57	2015	1610778	28259.263158	13412251.62	235302.660000	14597.50	256.096491	7.008422e+05	12295.477555	6.228006e+06	109263.259461
10321	55	2015	3713105	67511.000000	29392921.40	534416.752727	30355.36	551.915636	1.262452e+06	22953.674917	1.412957e+07	256901.347684
10322	50	2015	2943145	58862.900000	22235886.28	444717.725600	23665.57	473.311400	4.029754e+05	8059.508087	4.251579e+06	85031.585415
10323	50	2015	2943145	58862.900000	22235886.28	444717.725600	23665.57	473.311400	4.029754e+05	8059.508087	4.251579e+06	85031.585415

Most frequently occurring

	country_qtycount	del_date_scheduled_yr	country_qtysum	country_qtymean	country_valsum	country_valmean	country_inssum	country_insmean	country_weightsum	country_weightmean	country_costsum	country_costmean	# duplicates
205	343	2014	65366	190.571429	1283746.29	3742.700554	1533.55000	4.470991	1.108872e+04	32.328622	8.024486e+05	2339.500429	343
204	298	2009	595062	1996.852349	7079591.28	23757.017718	13904.90000	46.660738	9.042055e+04	303.424653	5.247788e+06	17610.026047	298
203	228	2015	15194	66.640351	468161.63	2053.340482	535.39000	2.348202	2.068879e+03	9.074031	6.343921e+04	278.242147	228
202	210	2010	3548124	16895.828571	33869606.52	161283.840571	72852.29000	346.915667	5.860529e+05	2790.728243	2.842281e+07	135346.726013	210
201	196	2011	15436074	78755.479592	67742339.79	345624.182602	123010.43000	627.604235	2.735926e+06	13958.804265	1.466147e+08	748034.227104	196
200	185	2009	2443751	13209.464865	35452389.84	191634.539676	69622.10000	376.335676	1.079001e+06	5832.439302	2.560016e+07	138379.261330	185
199	171	2010	1515631	8863.339181	14919430.41	87248.131053	31461.79000	183.987076	3.945808e+05	2307.489939	5.847371e+06	34195.149682	171
198	167	2013	3779574	22632.179641	28476197.72	170516.154012	35536.51000	212.793473	9.377679e+05	5615.376718	9.692430e+06	58038.504228	167
197	164	2007	1145218	6983.036585	12069370.48	73593.722439	14407.37005	87.849817	1.747381e+05	1065.476205	5.882010e+06	35865.915474	164
196	149	2010	5829963	39127.268456	26199468.38	175835.358255	56469.83000	378.992148	9.296079e+05	6238.979364	6.732375e+07	451837.240822	149

Overview

Variables

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring